package cn.wolfcode.mapper;

import cn.wolfcode.domain.Dept;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface DeptMapper {
    @Select("""
         select id, name, create_time, update_time from dept
     """)
    List<Dept> list();
@Delete("""
        delete  from dept where id = #{id}
        """)
    void delete(Long id);
@Insert("""
insert  into dept ( name, create_time, update_time)
values (#{name},now(),now())
""")
    void save(Dept dept);
@Select("""
                select * from dept where id = #{id};
""")
    Dept getById(Long id);
@Update("""
  update dept
  set name =#{name},
  update_time =now()
where  id = #{id} ;
""")
    void update(Dept dept);
}
